You might receive the following error message from PROC OLAP:

ERROR: A duplicate member caption was found in <level-name>  
       level for value <value>. 
ERROR: The class ordinals cannot be initialized. 
ERROR: Cube <cube-name> cannot be created. 

In most cases, the member caption or captions referred to by this error are derived from the non-measure variable values of your input data source. It may be that the same caption exists with different variants of upper and lower case characters, or with a different number of leading blanks. The MDX language is case tolerant, so having one or more captions that differ only in the case or number of leading blanks makes the captions ambiguous.

Using the MDX standard in SAS^® 9.1, values differing only in case or in leading blanks are not allowed and they should be resolved. For example 'Canada' and 'cANADA' are considered to be ambiguous.

Note that only the first encountered ambiguous value is reported. Therefore, your data might contain additional ambiguous values that need to be resolved before trying to load the cube again.

You might want to try to cleanse small- to medium- sized data using the PROPCASE, UPCASE, or LOWCASE SAS functions or, for large-sized data, use SAS^® Data Quality software. Using the STRIP function might also help, as it will remove leading or trailing blanks from your values.

In SAS 9.1, the level and member name are reversed. Starting in SAS 9.2, this error provides the correct level name and member name.

Operating System and Release Information